package com.jackykeke.kdatabasedemo.db.interfaze

import com.jackykeke.kdatabasedemo.db.DatabaseUtils


interface ITable {

    companion object {
        val SQL_SYMBOL_COMMA = ", "


        val SQL_SYMBOL_SPACE = " "

        /***************************建表常用语句*************************************/
        val PRIMARY_KEY_SQL = "PRIMARY KEY (%s)"

        val CREATE_TABLE_SQL = "CREATE TABLE IF NOT EXISTS "


        /**
         * 自增主键
         */
        val CREATE_PRIMARY_KEY_AUTO_INCREMENT="_id integer PRIMARY KET AUTOINCREMENT "+ SQL_SYMBOL_COMMA


        /****************************数据类型**************************************/
        val DATA_TYPE_BLOB= SQL_SYMBOL_SPACE+DatabaseUtils.TYPE_BLOB

        val DATA_TYPE_TEXT= SQL_SYMBOL_SPACE+DatabaseUtils.TYPE_TEXT

        val DATA_TYPE_NUMERIC= SQL_SYMBOL_SPACE+DatabaseUtils.TYPE_NUMERIC

        var DATA_TYPE_TEXT_TEXT = DATA_TYPE_TEXT + SQL_SYMBOL_COMMA

        var DATA_TYPE_BLOB_TEXT = DATA_TYPE_BLOB + SQL_SYMBOL_COMMA

        var DATA_TYPE_NUMERIC_TEXT = DATA_TYPE_NUMERIC + SQL_SYMBOL_COMMA

    }


}




































